﻿/****************************** Module Header ******************************\
 * Module Name:  tGeneralSpecification.cs
 * Module Version:  1.0.0 (2013-01-25)
 * Copyright (c) AnyEB.Com (14507247@qq.com)
 * 
 * This source is subject to the GPL License.
 * See http://www.gnu.org/licenses/gpl.html.
 * All other rights reserved.
 * 
 * THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, 
 * EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED 
 * WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE.
\***************************************************************************/

using System;

namespace UCL.Data.ORM.UMD
{
    /// <summary>
    /// 通用-类型和规格 数据实体类
    /// </summary>
    [DBTable(Common = "通用-类型和规格")]
    public class tGeneralSpecification
    {
        /// <summary>
        /// Guid编号
        /// </summary>
        public Guid ID { get { return _ID ?? default(Guid); } set { _ID = value; } }

        [DBColumn(Alias = "Guid编号", IsKey = true, DefaultValue = "newid()")]
        private Guid? _ID;

        /// <summary>
        /// 规格或类型名称
        /// </summary>
        public string Name { get { return _Name; } set { _Name = value; } }

        [DBColumn(Alias = "规格或类型名称", Length = "32")]
        private string _Name;

        /// <summary>
        /// 规格值
        /// </summary>
        public string Value { get { return _Value; } set { _Value = value; } }

        [DBColumn(Alias = "规格值", CanBeNull = true, Length = "Max")]
        private string _Value;

        /// <summary>
        /// 品项编号(如商品编号)
        /// </summary>
        public Guid ItemID { get { return _ItemID ?? default(Guid); } set { _ItemID = value; } }

        [DBColumn(Alias = "品项编号", Common = "如商品编号", CanBeNull = true)]
        private Guid? _ItemID;

        /// <summary>
        /// 品项价格
        /// </summary>
        public decimal ItemPrice { get { return _ItemPrice ?? default(decimal); } set { _ItemPrice = value; } }

        [DBColumn(Alias = "品项价格", CanBeNull = true)]
        private decimal? _ItemPrice;

        /// <summary>
        /// 品项库存
        /// </summary>
        public int ItemStock { get { return _ItemStock ?? default(int); } set { _ItemStock = value; } }

        [DBColumn(Alias = "品项库存", CanBeNull = true)]
        private int? _ItemStock;

        /// <summary>
        /// 排列次序
        /// </summary>
        public short Ordinal { get { return _Ordinal ?? default(short); } set { _Ordinal = value; } }

        [DBColumn(Alias = "排列次序", DefaultValue = "999")]
        private short? _Ordinal;

        /// <summary>
        /// 扩展标签(如：Color=颜色,Size=尺码)
        /// </summary>
        public string ExTags { get { return _ExTags; } set { _ExTags = value; } }

        [DBColumn(Alias = "扩展标签", Length = "16")]
        private string _ExTags;

        /// <summary>
        /// 状态
        /// </summary>
        public short State { get { return _State ?? default(short); } set { _State = value; } }

        [DBColumn(Alias = "状态", DefaultValue = "0")]
        private short? _State;

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime CreatedTime { get { return _CreatedTime ?? default(DateTime); } set { _CreatedTime = value; } }

        [DBColumn(Alias = "创建时间", DefaultValue = "getdate()")]
        private DateTime? _CreatedTime;

        /// <summary>
        /// 最后更新时间
        /// </summary>
        public DateTime ModifiedTime { get { return _ModifiedTime ?? default(DateTime); } set { _ModifiedTime = value; } }

        [DBColumn(Alias = "最后更新时间", CanBeNull = true)]
        private DateTime? _ModifiedTime;

        /// <summary>
        /// 是否删除
        /// </summary>
        public bool IsDeleted { get { return _IsDeleted ?? default(bool); } set { _IsDeleted = value; } }

        [DBColumn(Alias = "是否删除", DefaultValue = "0")]
        private bool? _IsDeleted;

        /// <summary>
        /// 网站标签
        /// </summary>
        public string SiteTag { get { return _SiteTag; } set { _SiteTag = value; } }

        [DBColumn(Alias = "网站标签", CanBeNull = true, Length = "16")]
        private string _SiteTag;

    }
}
